/**
 * 
 */
package com.dingding.facade.mall.sql;

/**
 * @ClassName: UserCommodityOrderSQL
 * @Description:获取用户订单列表
 * @author zhouxuan
 * @date 2016年3月25日 上午10:27:17
*/

public class UserCommodityOrderSQL {

	
	//获取用户订单列表
	public static final String GET_USER_COMMODITY_ORDER_SQL = "SELECT c.commodityName,uco.commodityPrice,c.commodityId,c.commodityBackGroundPic,c.commodityThumbnailName,uco.createTime FROM usercommodityorder uco INNER JOIN commodity c ON uco.commodityId = c.commodityId WHERE uco.loginId = ? ORDER BY uco.createTime desc ";
	
	//获取优惠券详情
	public static final String GET_COMMODITY_INFO_SQL = "SELECT cd.commodityPrice,cd.commodityDescription,cd.commodityName FROM commodity cd WHERE cd.commodityId = ?";
}
